Stored Procedures [dbo].[BAEErrorUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ErrorIDint4
@StackTracevarchar(255)255
@FriendlyErrorMessagevarchar(255)255
@ErrorTypevarchar(255)255
@ErrorDatedatetime8
@HttpRefervarchar(255)255
@HttpPathvarchar(255)255
@HttpHostvarchar(255)255
@HttpAllvarchar(255)255
@UserIDvarchar(255)255
@CookieDatavarchar(255)255
SQL Script
create procedure [dbo].[BAEErrorUpdate] @ErrorID as
int,
    @StackTrace     AS     varchar(255),
    @FriendlyErrorMessage    AS    varchar(255),
    @ErrorType    AS    varchar(255),
    @ErrorDate    AS    datetime,
    @HttpRefer    AS    varchar(255),
    @HttpPath    AS    varchar(255),
    @HttpHost    AS    varchar(255),
    @HttpAll    AS    varchar(255),
    @UserID    AS    varchar(255),
    @CookieData    AS    varchar(255)
AS
    UPDATE Error
    SET
    StackTrace = @StackTrace,
    FriendlyErrorMessage = @FriendlyErrorMessage,
    ErrorType = @ErrorType,
    ErrorDate = @ErrorDate,
    HttpRefer = @HttpRefer,
    HttpPath = @HttpPath,
    HttpHost = @HttpHost,
    HttpAll = @HttpAll,
    UserID = @UserID,
    CookieData = @CookieData

    WHERE ErrorID = @ErrorID;

GO
Uses